package data

import (
	"context"
	"github.com/go-kratos/kratos/v2/log"
	"gorm.io/gorm"
	"phm/internal/biz"
	"phm/models/generator/model"
	"phm/models/generator/query"
)

type scMajorRepo struct {
	Db  biz.DataRepo
	log *log.Helper
}

func NewScMajorRepo(data biz.DataRepo, logger log.Logger) biz.ScMajorRepo {
	return &scMajorRepo{Db: data, log: log.NewHelper(logger)}
}

func (u *scMajorRepo) CreateScMajor(ctx context.Context, uModel *model.ScMajor, db *gorm.DB) error {
	var s = db
	if db == nil {
		s = u.Db.GetDB()
	}
	opt := query.Use(s).ScMajor
	err := opt.WithContext(ctx).Create(uModel)
	if err != nil {
		return err
	}
	return nil
}

func (u *scMajorRepo) UpdateScMajor(ctx context.Context, uModel *model.ScMajor, db *gorm.DB) error {
	var s = db
	if db == nil {
		s = u.Db.GetDB()
	}
	opt := query.Use(s).ScMajor
	info, err := opt.WithContext(ctx).Where(opt.ID.Eq(uModel.ID)).Updates(uModel)
	u.log.Info(info)
	if err != nil {
		u.log.Errorf("更新错误：%v", err)
		return err
	}
	return nil
}

func (u *scMajorRepo) DeleteScMajorByIds(ctx context.Context, ids []string, db *gorm.DB) error {
	var s = db
	if db == nil {
		s = u.Db.GetDB()
	}
	role := query.Use(s).ScMajor
	info, err := role.WithContext(ctx).Where(role.ID.In(ids...)).Delete()
	u.log.Info(info)
	if err != nil {
		u.log.Errorf("删除错误：%v", ids)
		return err
	}
	return nil
}

func (u *scMajorRepo) GetScMajorById(ctx context.Context, id string) (*model.ScMajor, error) {
	s := u.Db.GetDB()
	opt := query.Use(s).ScMajor
	user, err := opt.WithContext(ctx).Where(opt.IsSoftDelete.Eq(0), opt.ID.Eq(id)).First()
	if err != nil {
		return nil, err
	}
	return user, nil
}

func (u *scMajorRepo) GetScMajorByIds(ctx context.Context, ids []string) ([]*model.ScMajor, error) {
	s := u.Db.GetDB()
	opt := query.Use(s).ScMajor
	users, err := opt.WithContext(ctx).Where(opt.IsSoftDelete.Eq(0), opt.ID.In(ids...)).Find()
	if err != nil {
		return nil, err
	}
	return users, nil
}

func (u *scMajorRepo) GetScMajorList(ctx context.Context, queryParam string, pageNum, pageSize int64) ([]*model.ScMajor, int64, error) {
	s := u.Db.GetDB()
	opt := query.Use(s).ScMajor
	if pageNum == 0 && pageSize == 0 {
		radars, err := opt.WithContext(ctx).Where(opt.IsSoftDelete.Eq(0)).Find()
		if err != nil {
			return nil, 0, err
		}
		return radars, 0, nil
	}
	list, err := opt.WithContext(ctx).Where(opt.IsSoftDelete.Eq(0)).Limit(int(pageSize)).Offset(int((pageNum - 1) * pageSize)).Find()
	if err != nil {
		return nil, 0, err
	}
	// 计算总数
	count, _ := opt.WithContext(ctx).Count()
	return list, count, nil
}

func (u *scMajorRepo) GetDB() *gorm.DB {
	return u.Db.GetDB()
}
